Page 43 - Data_Science_Part_A C12

• Insert: This menu contains commands like Image, Media, Chart, OLE Object, Shape, Date, Time, Headers and Footers,
and so on. These commands are used for inserting elements into a spreadsheet.

• Format: This menu contains commands like Cells, Rows, Columns, Page Style, Align Text and so on. These commands
are used for modifying the layout of spreadsheet.

• Styles: This menu contains commands like new style from Selection, Update Selected Style, Manage Styles and so on.
These commands are used for managing styles.

• Sheet: This menu contains commands like Insert Cells, Insert Rows, Insert Columns, Delete Cells, Rename Sheet,
Move or Copy Sheet and so on.
• Data: This menu contains commands like Sort, Define Range, Subtotals, Consolidate, Group and Outline and so on.
These commands are used for manipulating data.
• Tools: This menu contains commands like Spelling, Goal Seek, Solver, Protect Sheet, Macros and so on. These
commands are used to check and customise spreadsheet.
• Window: This menu contains commands like New Window, Close Window and so on. These commands are used to
display window.
• Help: This menu contains commands like LibreOffice Help, User Guide, Get Help Online, Check For Update and so
on. These commands contains links to the help system included in the software and other miscellaneous functions.

3.3.3 Toolbars

By default LibreOffice Calc opens with the Standard and Formatting toolbars at the top of the workspace. These toolbars
offer a wide range of common commands and functions. Hovering the mouse cursor over any icon displays a tooltip,
which provides a brief explanation of the icon's function.

3.3.4 Formula Bar

Formula bar lies below the formatting toolbar. Formula that performs different calculations in cells is entered and
displayed here. It is denoted by 'fx'.
Function Wizard Formula

Name Box Select Function Input Line

It is used for entering and editing the formula in the cell. Formula bar consists of:
• Name Box: It displays the cell reference, for example A1 or D10.
• Functions Wizard: It consists of a list of available functions that we can search.

• Select Function: Click the Select Function drop-down list in the Formula bar opens a list of functions. You can
quickly select common functions like Sum, Average, Min, Max and so on. After choosing a function, its name appears
in the formula bar. Enter the required arguments directly in the formula bar or in the cell. For example, selecting SUM
allows you to type the range of cells to sum, such as A1:A5. By default, the Select Function tool in LibreOffice Calc
typically opens with the SUM function selected.
• Formula: In LibreOffice Calc, the = symbol initiates a formula or function. It tells Calc to interpret the following text
as a formula rather than a regular piece of text or a number. For example:

=A1+B1 adds the values in cells A1 and B1.
=SUM(A1:A5) calculates the total of the values in cells A1 through A5.
The = symbol is essential for enabling calculations and functions in spreadsheet cells.
• Input Line: It displays the contents of the selected cell (data, formula, or function). It allows editing of the cell
contents. Click in the area and, then type the changes. To edit within the current cell, just double-click in the cell.

ICT Skills-III 41